Interview Questions

1. How to create Calculations?

Options:

a. Using Calculation designer

b. Using form view

c. Using Script view

d. None of these

Reveal Answer

2. Define some calculation tools?

Options:

a. Metadata

b. Functions

c. Template

d. None of these

Reveal Answer

3. Any changes to the existing cube can be done only in ________?

Options:

a. SSDT

b. SSMS

c. All the above

d. None of these

Reveal Answer

4. What are the different types of calculated members?

Options:

a. Query scoped calculated members

b. Session scoped calculated members

c. Global scoped calculated members

d. None of these

Reveal Answer

5. What do you understand by dynamic named set (SSAS 2008)?

Options:

a. To create a dynamic set of members

b. To create set of members

c. None

d. Both a and b

Reveal Answer

6. CALCULATE statement is used to populate each cell in the cube with aggregated data?

Options:

a. True

b. False

Reveal Answer

Interview Questions and Answer

1. How to create Calculations?

2. Define some calculation tools?

3. Any changes to the existing cube can be done only in ________?

4. What are the different types of calculated members?

5. What do you understand by dynamic named set (SSAS 2008)?

6. CALCULATE statement is used to populate each cell in the cube with aggregated data?

Packages

Trending Certification Courses:

Microsoft Mock Exams:

Other links

About

Resources